home *** CD-ROM | disk | FTP | other *** search
Gold Disk Spreadsheet | 1991-12-11 | 6.6 KB | 133 lines |
- Gadgets and Widgets INC
- Balance Sheet
- Current Assets
- Cash
- 12000
- 30000
- 10000
- 55000
- 100000
- Accounts Receivable
- 35000
- 28000
- 25000
- 20000
- 15000
- Inventory
- 91000
- 102000
- 150000
- 100000
- 80000
- Raw Material
- 15000
- 17000
- 13000
- 10000
- 10000
- Work-In-Progress
- 12000
- Finished Goods
- 40000
- 50000
- 75000
- 49000
- 25000
- Total Current Assets
- 201000
- 233000
- 278000
- 243000
- 242000
- Fixed Assets
- Land
- 21000
- Plant
- 355500
- 350500
- 330000
- 330000
- 380000
- Equipment
- 250000
- 240000
- 250000
- 284500
- 300000
- Total Fixed Assets
- 605500
- 590500
- 580000
- 614500
- 701000
- Total Assets:
- 806500
- 823500
- 858000
- 857500
- 943000
- Current Liabilities
- Accounts Payable
- 17000
- 19000
- 21000
- 25000
- 30000
- Salaries Payable
- 10000
- 10000
- Taxes Payable
- Short-term Loans
- Total Liabilites
- 25000
- 28000
- 30500
- 41500
- 53000
- Long Term Debt
- Term Loans
- 100000
- 100000
- 147500
- 100000
- 100000
- Bond Issues
- SBA Loans
- 115000
- 112000
- 100000
- 100000
- 100000
- Total Long-term Debt
- 215000
- 212000
- 247500
- 200000
- 200000
- Net Worth
- Preferred Stock
- Common Stock
- 300000
- 300000
- 300000
- 300000
- 300000
- Retained Earnings
- 266500
- 283500
- 280000
- 316000
- 390000
- Total Net Worth
- 566500
- 583500
- 580000
- 616000
- 690000
- Liabilites + Equity
- 806500
- 823500
- 858000
- 857500
- 943000
-